De-duplication Audit

The de-duplication functionality has an audit table where successful merges can be reviewed. Under the FES schema, the table PEOPLE_DEDUPLICATION_AUDIT stores the following information:

• merged_from (the old person code)
• merged_to (the new person code)
• merged_by
• merged_on
• old_surname
• old_forename
• old_middle_names
• old_initials
• old_dob

This table is only used to review the records that have been deleted. The user will not be able to reverse the de-duplication.